Microsoft Excel 2013 Study Guide:
Advanced Excel
Microsoft Office Specialist (MOS): Exams 77-427 and 77-428 Expert for Excel 2013
From the Excel 2013 Expert Exams
1. Manage and Share Workbooks,
1.1 Manage Multiple Workbooks
Copy Macros between Workbooks, Pg 275
Copy Styles between Templates, Pg 243
Link to External Data, Pg 293
Merge Workbooks, Pg 219
Modify Templates, Pg 242
Version Control, Pg 222
1.2 Prepare A Workbook for Review
Developer: Restrict Editing, Pg 233
Encrypt with a Password, Pg 210
Mark as Final, Pg 230
Protect Worksheet Structure, Pg 229
Remove Workbook Metadata, Pg 226
Review: Create Workspaces, Pg 219
Review: Set Tracking Options, Pg 209
1.3 Manage Workbook Changes
Review: Display All Changes, Pg 212
Review: Manage Comments, Pg 215
Review: Retain All Changes, Pg 214
Review: Track Changes, Pg 211
From the Excel 2013 Expert Exams
2. Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats
Custom Data Formats: Accounting, Pg 299
2.2 Advanced Conditional Formatting and Filtering
Create Advanced Filters, Pg 40
Custom Formatting, Pg 39
Manage the Rules, Pg 38
Use Functions to Format Cells, Pg 31
2.3 Apply Custom Styles and Templates
Create Form Fields, Pg 187
Custom Styles: Custom Color Format, Pg 235
Custom Templates, Pg 241
2.4 Prepare a Workbook for Internationalization and Accessibility
Accessibility Tools, Pg 228
Custom Formats: International Formats, Pg 319
Custom Formats: International Symbols, Pg 299
From the Excel 2013 Expert Exams
4. Create Advanced Charts and Tables
4.1 Create Advanced Chart Elements
Charts: Custom Chart Templates, Pg 238
Charts: View Chart Animations, Pg 137
4.2 Create and Manage PivotTables
PivotTable: Create a Slicer, Pg 149
PivotTable: Create New PivotTables, Pg 87
PivotTable: Format Data, Pg 111
PivotTable: Group Records, Pg 102
PivotTable: Manage Relationships, Pg 312
PivotTable: Modify Fields and Options, Pg 96
PivotTable: Use Calculated Fields, Pg 315
PivotTable: Use Power Pivot!, Pg 298
4.3 Create and Manage Pivot Charts
PivotChart: Create New PivotCharts, Pg 123
PivotChart: Edit the Options, Pg 125
PivotChart: Apply Styles, Pg 137
